from django.db import models

# Create your models here.
class MyupUser(models.Model):
    username = models.CharField(max_length=50, null=True)
    userprice = models.IntegerField(default=0)
    password = models.CharField(max_length=10, null=True)
    vipuser = models.IntegerField(default=0)
    class Meta:
        db_table = 'myupuser'

class MyupCoupon(models.Model):
    coupon=models.CharField(max_length=50, null=True)
    uid=models.IntegerField(null=True)
    gid=models.IntegerField(null=True)

    class Meta:
        db_table = 'myupcoupon'


class MyupGoods(models.Model):
    gid = models.IntegerField(null=True)
    title = models.CharField(max_length=100, null=True)
    img = models.CharField(max_length=200, null=True)
    price = models.IntegerField(null=True)
    vip_price = models.IntegerField(null=True)
    uid = models.IntegerField(null=True)
    num=models.IntegerField(null=True)

    class Meta:
        db_table = 'myupgoods'


class MyupIndex(models.Model):
    uid = models.IntegerField(null=True)
    title = models.CharField(max_length=100, null=True)
    price = models.IntegerField(null=True)
    username = models.CharField(max_length=50, null=True)
    num=models.IntegerField(null=True)
    youhun=models.CharField(max_length=50,null=True)
    rprice=models.IntegerField(null=True)
    lprice = models.IntegerField(null=True)
    class Meta:
        db_table = 'myupindex'


